home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Magnum One
/
Magnum One (Mid-American Digital) (Disc Manufacturing).iso
/
d16
/
winsql.arc
/
README.DOC
< prev
Wrap
Text File
|
1991-06-02
|
11KB
|
236 lines
General Information Page 1 of 4
Orion SQL For Windows
Release 1.0 - June 1991
GENERAL INFORMATION
Copyright (c) 1991 by Stellar Industries
All Rights Reserved
Unpacking and Installation Instructions
Orion SQL For Windows is provided as a single compressed file.
(WINSQL.ZIP). The contents of WINSQL.ZIP are defined in the
included PACKING.LST file. In order to properly install SQL
For Windows on your computer you will need to perform the
following steps:
1) Move DBA.EXE, DBA.HLP, QE.EXE and QE.HLP to the directory
in which you keep windows programs. This is usually the
'c:\windows' directory.
2) Make two new directories. One will be for the Orion
Database Administrator's files (we recommend naming it
'database'), the other will be for your queries and data
(we recommend naming it 'data'). You can use the MS-DOS
'mkdir' command to do this.
3) Unpack EXAMPLES.ZIP (contained within WINSQL.ZIP). This
file contains both sample queries and an import file to
load some sample data into the database. We recommend
putting these files in your 'data' directory.
4) Use your favorite editor (NOTEPAD.EXE will suffice) to
modify the windows initialization file WIN.INI. This
file can usually be found in the 'c:\windows' directory.
Add the following lines:
[OrionDba]
AutoStart=0
DatabasePath=c:\database
DataFilePath=c:\data
FileNameDatabaseDump=c:\temp\orion.dmp
Suspend=0
[OrionQe]
Acknowledge=1
AutoStart=0
DataFilePath=c:\data
OpenNew=0
UserName=SYSTEM
UserPassword=ORION
WarnOnClose=1 General Information Page 2 of 4
As DBA.EXE and QE.EXE automatically add some of these
lines if they do not already exist, be sure you are not
adding duplicate entries. If you edit WIN.INI before
running DBA.EXE or QE.EXE you don't have to worry.
These entries have the following meanings:
[OrionDba] Identifies a block of entries as
belonging to the Orion Database
Administrator.
AutoStart Set to '0' or '1'. When set to '1'
causes the Orion Database
Administrator to automatically start
the database as soon as you start the
program.
DatabasePath Set to the path you want the database
files to reside in. Make sure to
create this directory before starting
the Orion Database Administrator. We
recommend naming it 'database'.
DatafilePath Set to the path you want to use as
the default for import and export
operations. We recommend naming it
'data'.
FileNameDatabaseDump Set to the full file name of the
file you want the Orion Database
Administrator to use for the 'dump'
operation.
Suspend Set to '0'.
[OrionQe] Identifies a block of entries as
belonging to the Orion Query Editor.
Acknowledge Set to '0' or '1'. When set to '1'
causes the Orion Query Editor to
display an informational dialog box
every time a query completes.
AutoStart Set to '0' or '1'. When set to '1'
causes the Orion Query Editor to
automatically start the Orion
Database Administrator if it is not
already running.
DataFilePath Set to the path you want to use as
the default for file operations. We
recommend naming it 'data'.
OpenNew Set to '0' or '1'. When set to '1'
causes the Orion Query Editor to
automatically create a new 'pad' when
the Query Editor first starts. General Information Page 3 of 4
UserName Set to 'SYSTEM'. This identifies the
default user name.
UserPassword Set to 'ORION'. This identifies the
default user password.
WarnOnClose Set to '0' or '1'. When set to '1'
causes the Orion Query Editor to
prompt the user for a file name
before closing a pad which contains
text not yet saved to disk.
SQL For Windows also relies upon the international date
and time settings. The Windows defaults are fine and you
can leave them alone. If you've changed them, don't
worry, time stamps are saved in binary and not converted
to international format until used for output. If you're
interested, we recommend the following settings:
[intl]
iDate=0
iTime=0
s1159=AM
s2359=PM
International date and time settings are most easily
changed via Microsoft's Windows Control Panel. Select
the "International" icon then click on either "date" or
"time".
5) Use Microsoft's Program Manager to create a new program
group:
a) select 'File', 'New'
b) select 'Program Group', 'OK'
c) Enter description: 'Orion', group file: 'ORION'
d) select 'OK'
6) Use Microsoft's Program Manager to create two new program
items:
a) select 'File', 'New'
b) select Program Item, 'OK'
c) Enter description: 'Dba', command line: 'DBA.EXE'
d) select 'OK'
e) select 'File', 'New'
f) select Program Item, 'OK'
g) Enter description: 'Qe', command line: 'QE.EXE' General Information Page 4 of 4
h) select 'OK'
7) Start the Orion Database Administrator by clicking on the
'Dba' Icon in the Microsoft Program Manager. When the
Orion Database Administrator's window appears select
'Toolbox' from its menu. Select the 'Install' entry,
this will install the database in the directory
identified by the 'DatabasePath' setting described above.
8) You may now exit ('Exit' is in the 'File' menu) the Orion
Database Administrator. SQL For Windows is completely
installed.
Examples
You will probably want to run our examples to familiarize
yourself with the operation of SQL For Windows.
1) Start the Orion Database Administrator by clicking on the
'Dba' Icon in the Microsoft Program Manager. When the
Orion Database Administrator's window appears select
'Control' from its menu. Select the 'Start' entry, this
will start the database.
2) Start the Orion Query Editor by clicking on the 'Qe' icon
in the Microsoft Program Manager. When the Orion Query
Editor's window appears select 'File' from its menu. Now
select the 'Open' entry and open the file CREATE.SQL.
This is one of the files contained in EXAMPLES.ZIP. When
its text appears in a pad select the menu commands
'Database', 'Execute' (or hit control/x). This query
creates the tables of the example database.
3) Now go to the Orion Database Administrator and select the
menu commands 'File', 'Import'. Select the file
EXAMPLE.DAT. This is one of the files contained in
EXAMPLES.ZIP. The 'Import' loads the data in EXAMPLE.DAT
into the tables you created with CREATE.SQL.
4) You can now execute any of the sample queries contained
in EXAMPLES.ZIP. Go to the Orion Query Editor, open a
file (for example QUERY01.SQL) and execute it. Files
which contain select statements will cause the Orion
Query Editor to open a new pad and place the data as text
into the new pad. You may then edit the data and/or save
it to a file using the 'File', 'Save As' commands.
5) To remove the sample data from the database just execute
the SQL 'drop table' statements in the DROP.SQL file.
6) You are now ready to write your own SQL statements and
create your own database.
Stellar Industries: (714) 861-7885
3335 S. Falcon Ridge Road
Diamond Bar, CA 91765